<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>layui</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="/admin/lib/layui-v2.6.3/css/layui.css" media="all">
    <link rel="stylesheet" href="/admin/css/public.css" media="all">
    <style type="text/css">
        .layui-table-cell{
            height: auto;
            line-height: 80px;
        }
    </style>
</head>
<body>
<div class="layuimini-container">
    <div class="layuimini-main">

        <fieldset class="table-search-fieldset">
            <legend>搜索信息</legend>
            <div style="margin: 10px 10px 10px 10px">
                <form class="layui-form layui-form-pane" action="">
                    <div class="layui-form-item">
                        <div class="layui-inline">
                            <label class="layui-form-label">小区名称</label>
                            <div class="layui-input-inline">
                                <input type="text" name="plotName" autocomplete="off" class="layui-input">
                            </div>
                        </div>
                        <div class="layui-inline">
                            <button type="submit" class="layui-btn layui-btn-primary"  lay-submit lay-filter="data-search-btn"><i class="layui-icon"></i> 搜 索</button>
                        </div>
                    </div>
                </form>
            </div>
        </fieldset>

        <fieldset class="table-search-fieldset">
            <legend>导入导出</legend>
            <div style="margin: 10px 10px 10px 10px">
                <form class="layui-form layui-form-pane" action="">
                    <div class="layui-form-item">
                        <button type="button" class="layui-btn" id="uploadExcel"><i class="layui-icon"></i>上传文件</button>
                        <button type="button" class="layui-btn" id="downloadExcel">下载文件</button>
                    </div>
                </form>
            </div>
        </fieldset>

        <script type="text/html" id="toolbarDemo">
            <div class="layui-btn-container">
                <button class="layui-btn layui-btn-normal layui-btn-sm data-add-btn" lay-event="add"> 添加 </button>
                <button class="layui-btn layui-btn-sm layui-btn-danger data-delete-btn" lay-event="delete"> 删除 </button>
            </div>
        </script>

        <table class="layui-hide" id="currentTableId" lay-filter="currentTableFilter"></table>

        <script type="text/html" id="currentTableBar">
            <a class="layui-btn layui-btn-normal layui-btn-xs data-count-edit" lay-event="edit">编辑</a>
            <a class="layui-btn layui-btn-xs layui-btn-danger data-count-delete" lay-event="delete">删除</a>
        </script>


    </div>
</div>
<script src="/admin/lib/layui-v2.6.3/layui.js" charset="utf-8"></script>
<script>
    layui.use(['form', 'table','upload'], function () {
        var $ = layui.jquery,
            form = layui.form,
            upload = layui.upload;
            table = layui.table;

            //导入excel
        upload.render({//允许上传的文件后缀
            elem:'#uploadExcel'
            ,url:"/plot?method=uploadExcel"  //改成你的上传接口
            ,accept:'file'           //普通文件
            ,exts:'xls|xlsx'        //只允许上传压缩文件
            ,done:function (res){
                if(res.code==0){
                    layer.msg(res.msg);
                    table.reload('currentTableId', {
                        url: '/plot?method=selectAll'
                    });
                }else{
                    layer.msg(res.msg);
                }
            }
        });

        $("#downloadExcel").click(function (){
            //不能发送异步请求（返回json）   需发送同步请求
            //下面四种方式都可以
            // window.location.href="";
            // window.location="";
            // location.href="";
            // location="";
            location.href="/plot?method=downloadExcel";
        })



        table.render({
            elem: '#currentTableId',
            url: '/plot?method=selectAll',
            toolbar: '#toolbarDemo',
            defaultToolbar: ['filter', 'exports', 'print', {
                title: '提示',
                layEvent: 'LAYTABLE_TIPS',
                icon: 'layui-icon-tips'
            }],
            cellMinWidth: 80 ,//全局定义常规单元格的最小宽度，layui 2.2.1 新增
            cols: [[
                {type: "checkbox"},
                {field: 'id',  title: 'ID', sort: true},
                {field: 'plotNum', title: '小区编号'},
                {field: 'plotName',  title: '小区名称'},
                {field: 'plotLocation',  title: '坐落地址'},
                {field: 'plotArea',  title: '占地面积(㎡)', sort: true},
                {field: 'buildNum',  title: '总栋数', sort: true},
                {field: 'familyNum',  title: '总户数', sort: true},
                {field: 'greenRate',  title: '绿化率(%)', sort: true},
                {field: 'image',  title: '缩略图' ,templet: function(res){
                        return `<img src="http://localhost:8080/${res.image}" width="80px" height="80px">`
                    }},
                {field: 'developer', title: '开发商名称'},
                {field: 'tenementName', title: '物业公司名称'},
                {field: 'datecreated',  title: '创建时间', sort: true},
                {field:'status', title:'状态', templet:function(res){
                    if(res.status==0){
                        return `<button type="button" class="layui-btn layui-btn-warm">可用</button>`
                    }else{
                        return `<button type="button" class="layui-btn layui-btn-disabled">不显示</button>`
                    }
                    }},
                {title: '操作', minWidth: 150, toolbar: '#currentTableBar', align: "center"}
            ]],
            limits: [1, 3, 5, 10, 15, 100],
            limit: 5,
            page: true,
            skin: 'line'
        });

        // 监听搜索操作
        form.on('submit(data-search-btn)', function (data) {
            var result = JSON.stringify(data.field);
            layer.alert(result, {
                title: '最终的搜索信息'
            });

            $.ajax({
                url:"/plot?method=selectAll",
                data:{
                    plotName:data.field.plotName
                },
                type:"POST",
                success:function (res){
                    layer.msg(res.msg);
                    //执行搜索重载
                    table.reload('currentTableId', {
                        page: {
                            curr: 1
                        }
                        , where: {
                            plotName: data.field.plotName
                        }
                    }, 'data');
                }
            })
            return false;
        });

        /**
         * toolbar监听事件
         */
        table.on('toolbar(currentTableFilter)', function (obj) {
            if (obj.event === 'add') {  // 监听添加操作
                var index = layer.open({
                    title: '添加用户',
                    type: 2,
                    shade: 0.2,
                    maxmin:true,
                    shadeClose: true,
                    area: ['100%', '100%'],
                    content: '../page/table/addPlot.html',
                    end:function(){
                        table.reload('currentTableId', {
                            url: '/plot?method=selectAll'
                        });
                    }
                });
                $(window).on("resize", function () {
                    layer.full(index);
                });
            } else if (obj.event === 'delete') {  // 监听批量删除操作
                var checkStatus = table.checkStatus('currentTableId')
                    , data = checkStatus.data;
                //获取选择的checkBox中的ID
                var ids = new Array(data.length);
                $.each(data,function (index,plot){
                    ids[index]=plot.id;
                });
                //发送ajax异步请求，将ids传入后端进行删除
                $.ajax({
                    url:"/plot?method=delAll",
                    data:{
                        ids:JSON.stringify(ids)
                    },
                    success:function (res){
                        layer.msg(res.msg+"----"+res.code);
                        if(res.code==0){
                            //删除成功重载表格
                            table.reload('currentTableId', {
                                url: '/plot?method=selectAll'
                            });
                        }
                    }
                })




                layer.alert(JSON.stringify(data));
            }
        });

        //监听表格复选框选择
        table.on('checkbox(currentTableFilter)', function (obj) {
            console.log(obj)
        });

        table.on('tool(currentTableFilter)', function (obj) {
            var data = obj.data;
            if (obj.event === 'edit') {

                //将id保存到localStorage
                localStorage.setItem("id",data.id);

                var index = layer.open({
                    title: '编辑用户',
                    type: 2,
                    shade: 0.2,
                    maxmin:true,
                    shadeClose: true,
                    area: ['100%', '100%'],
                    content: '../page/table/editPlot.html',
                    end:function(){
                        table.reload('currentTableId', {
                            url: '/plot?method=selectAll'
                        });
                    }
                });
                $(window).on("resize", function () {
                    layer.full(index);
                });
                return false;
            } else if (obj.event === 'delete') {
                layer.confirm('真的删除行么', function (index) {
                    $.ajax({
                        url:"/plot?method=del",
                        type:"GET",
                        data:{
                            id:data.id
                        },success:function (res){
                            if(res.code==0){
                                console.log(data.id);
                                layer.msg(res.msg);
                                obj.del();
                            }else{
                                layer.msg(res.msg);
                            }
                        },
                        end:function(){
                            table.reload('currentTableId', {
                                url: '/plot?method=selectAll'
                            });
                        }
                    })

                    layer.close(index);
                });
            }
        });

    });
</script>

</body>
</html>